import openpyxl


workbook = openpyxl.load_workbook(f"富乐学校小学部原始数据明细表.xlsx")
# 获取体检数据表名[列表形式]
books = workbook.sheetnames
sheet = workbook['小学6年级14班']

print('未' in sheet['AA50'].value)
# for page in books:
#     sheet = workbook[f'{page}']
#     max_row = workbook[f'{page}'].max_row
#     for i in range(3,max_row+1):
#         if sheet[f'M{i}'].value is None and sheet[f'N{i}'].value is None and sheet[f'AB{i}'].value is None and sheet[f'AC{i}'].value is None and sheet[f'AS{i}'].value is None:
#             sheet[f'G{i}'].value = 0
#         else:
#             sheet[f'G{i}'].value = 1

workbook.save("富乐学校中学部原始数据明细表.xlsx")
print("表格处理完毕！")















